Copyright 1984-1998 FileMaker, Inc. 
HBAM2016AUG95
Pro 3.0
HBAM3016AUG95@
UXGSPNGXPPRVNMCDUa\N@OJQJTfmjIEN_PUNW?HOd^G<D_[S:@KRdS`[_SGK\TTCPO[TUMOJB@FQQ^eul`XQ[\XPPRVNMCDUa\N@OJQJTfmjIEN_PUNW?HOd^G<D_[NK
LPVOCDQ]_WUV][eXSGKPAKALCHEKZ
1st Quarter
2nd Quarter
3rd Quarter
4th Quarter
2/10/99
ARTIST NUMBER
CATEGORY
CONSTANT
COUNTLINES
FIRST NAME
INSERT STRING
ODBC DATASOURCE
PASSWORD
SQL STATEMENT
STATUS
SURNAME
USERNAME
Artist numberB
First NameB
SurnameB
CategoryB
statusB
insert stringB
odbc datasourceB
UsernameB
PasswordB
Sql statementB
ConstantB
CountlinesB
DataB
rowsB
create table artworks ( artwork_number varchar(12) , artist_number char(3) , title varchar(255) , maat varchar(12)  , price integer , year integer, extra varchar(255), style varchar(255) , category varchar(255) )
Intro
Populate
Create
Query 3
Query 2
A	Adres pdm
Rumora info
A	Help.menu
Help.intro
Help.create
Help.populate
Help.query2
Help.query3
"Insert into artists values ( '" & 
 & "','" & 
 "''")  & "','" & 
 "''") & "','" & 
 "''") & "' )"
Insert into artists values ( '
IntroB
PopulateB
Filemaker Pro ODBC/SQL PluginY7100 % Cross Platform (Macintosh AND Windows 95, 98, NT)Z
High Performance[,Fast Implementation in existing environments\
Connects to ANY ODBC Datasource
A=Import, Export, update, select data. Create views and Reports
^0Perform SQL Statements from within Filemaker Pro_&Export directly to TAB separated files`,Build live connections with ODBC Datasourcesa
MENUg
INTROh
CREATEi
POPULATEj
QUERYk
UPDATEl
Help & more info
CreateB
Artist numberD
First NameF
SurnameH
CategoryU
Insert stringW
database statusi
MENUo
INTROp
CREATEq
POPULATEr
QUERYs
UPDATEt
 Local Filemaker Pro data
Populate table artists~'note: this string is a caculation field
Populate table artworks
Help & more info
Artist numberD
First NameF
SurnameH
CategoryU
Insert stringW
database statusi
MENUo
INTROp
CREATEq
POPULATEr
QUERYs
UPDATEt
 Local Filemaker Pro data
Populate table artists~'note: this string is a caculation field
Populate table artworks
Help & more info
Query 3B
SQL statement:D
database status:E
MENUK
INTROL
CREATEM
POPULATEN
QUERYO
UPDATEP
Create table artistsS
odbc datasourceU
usernameW
passwordX
Connect[
Help & more infoh
Create table artworks
Query 2B
rowcount
Artwork noK
TitleL
PriceN	Artist noO
First nameP
SurnameR
StatusS
MENUW
INTROX
CREATEY
POPULATEZ
QUERY 3[
UPDATE\
GET ALL^
Select statement_
Help & more info
MenuB
Select statementD
DataE
MENUJ
INTROK
CREATEL
POPULATEM
QUERY 2N
UPDATEO
EXEC QUERYQ
GET ROWR
GET COLUMNU
StatusV
Help & more info
A	Adres pdmB
[tProfessional Data Management
Algolweg 20
3821 BH Amersfoort
THE NETHERLANDS
Tel. +31 33 4566183
Fax. +31 33 4566184
MENUG
INTROH
CREATEI
POPULATEJ
QUERYK
UPDATEL
MENUG
INTROH
CREATEI
POPULATEJ
QUERYK
UPDATEL
This demonstration file shows different ways of using and programming the ODBC/SQL Plugin.
Every now and then there will be new versions on our website of this files. Keep in touch!
Make sure you have the font Verdana installed for best viewing
Navigation tip: Follow the navigation in the tabs above from left to right to create everything in the right order
All databases are fully unlocked. All databases may be used in own projects except database design.
All design is (C)opyright of ProB*fessional Data Management, The Netherlands
NAWindows version: (click logo for address and contact information)OCMacintosh version: (click logo for address and contact information)P0This is a DEMONSTRATION file. Usage at own risk.Q
Help & more infoR
Demo version 1.0
Rumora infoB
Rumora Automatisering en Advies
Buiksloterdijk 212-214 
1025 WD AMSTERDAM
The Netherlands. 
Tel (+3120) 4940804, 
mobile phone (+316) 53460626, 
fax  (+3120) 4940805. 
Technical support: bane@xs4all.nl. 
Back to menu
A	Help.menuB
Support: (Windows only, Macintosh support is done by Rumora)
Preffered via e-mail: support@profdata.nl
If necessary you can call us our time zone is Central Europe (GMT + 1)
For U.S.A residents this means that if you want to call us, call us early in the morning.
Professional Data Mangement is specialized in:
- Filemaker Pro solutions
- Filemaker Pro plugins (also custom made plugins)
- E-commerce solutions (Filemaker Pro, Lotus Domino, MS SQL Server, Broadvision)
- Internet related databases
- JAVA programming_
Back to menu` Internet: http://www.profdata.nl
Help.introB
BackB0On nearly every screen you will see the button: C
Help & more info
EOby pressing this button you will get more information on what is on that layout
This demofile creates two tables in your datasource. It was built using MS SQL Server.
If you use another datasource (like Oracle you might need to edit some SQL statements
according to the specifications of your datasource. 
On the screens that use SQL statements there will be some additional information on how
to do this.
Although this demonstration files have been thoroughly tested we can not guarrantee that
they work correctly.
Help.createB
BackB0On nearly every screen you will see the button: C
Help & more infoEOby pressing this button you will get more information on what is on that layout
@NOTE: The plugin is NOT an ODBC driver. With the plugin you will not be able to allow
other applications to access Filemaker Pro files. At this moment there is only one option 
if you really need Filemaker data to be 
ODBC accessible
. Do the following:
Use the plugin to update a datasource and access that datasource.
Help.populateB
BackB0On nearly every screen you will see the button: C
Help & more infoEOby pressing this button you will get more information on what is on that layout
Before you create tables you have to make an ODBC datasource (if you don
t have one yet)
Please follow the instructions that come with your ODBC software on how to accomplish this.
After creating the datasource enter the name of the datasource into the Filemaker Pro field
and, if necessary, also enter the login information.
If you have access to a MS SQL Server, please use it. This file was created and tested with 
MS SQL 6.5 and 7. You can try anyway. It will work with most datasources
When you click on create the first table 
Artists
 will be created. In the table artists we will
put information on artists. The second table to be created is 
Artworks
. Click again on create 
to accomplish this. 
If you get error messages:
First enable Error reporting (first script under the script menu) and try to figure out
what the error is by reading the error message window.
- You might not have connected to the datasource
- Maybe the table(s) allready exist?
- Maybe your datC,asource is incompatible with the field types
Help.query2B
BackB0On nearly every screen you will see the button: C
Help & more infoEOby pressing this button you will get more information on what is on that layout
wThe table artists and artworks are filled with data from the Filemaker table artists and artworks.
This is done by using a calculated INSERT statement (have a look a the calculation field 
insert string). By looping through all records all data is inserted into the table.
If you get errors check this:
- Did you connect to your datasource?
- Did you create both tables?
Help.query3B
BackB0On nearly every screen you will see the button: C
Help & more infoEOby pressing this button you will get more information on what is on that layout
On this layout you can query the database yourself or use the sample query that is in 
the field SQl statement (Select statement).
You can retrieve one row at a time (Get Row) or you can get one Column at a time 
(GetColumn)
AartsH
Contemporary Modern ArtO
1Q	010114109
BertD
AbbingH
Contemporary Modern ArtO
DeliaD
AlbersenH
Contemporary Modern ArtO
GerritD
AlbertsH
Contemporary Modern ArtO
AlbertsH
Contemporary Modern ArtO
SaadD
Contemporary Modern ArtO
KarelD
AppelH
Classical ModernO
ArjanD
Van ArendonkH
Contemporary Modern ArtO
ArmanH
Classical ModernO
ArmandoH
Classical ModernO
MarianneD
AulmanH
Contemporary Modern ArtO
JokeD
BaasH
Contemporary Modern ArtO
PeterD
BastiaansenH
Contemporary Modern ArtO
PaulD
BeckersH
Contemporary Modern ArtO
CarlosD
BeukenH
Contemporary Modern ArtO
De BeusH
Contemporary Modern ArtO
TreesD
BoerH
Contemporary Modern ArtO
IlseD
De BoerH
Contemporary Modern ArtO
GorkiD
BollarH
Contemporary Modern ArtO
BackB0On nearly every screen you will see the button: C
Help & more infoEOby pressing this button you will get more information on what is on that layout
On this layout you can query the database yourself or use the sample query that is in 
the field SQl statement (Select statement).
This demo will export the found set to your local drive. And import the result into the
line items file li.fp3. This is the fastest way to get large amount of data inside filemaker 
On Windows all data is exported to C:\TEMPF.TAB. You can delete this file afterwards 
if you want to.
OlgaD
BontekoeH
Contemporary Modern ArtO
HermanD
Van De BoomH
Contemporary Modern ArtO
JacquelineD
Van De BosH
Contemporary Modern ArtO
KarinD
Contemporary Modern ArtO
113B	WillemijnD
BoumanH
Contemporary Modern ArtO
EelcoD
BrandH
Contemporary Modern ArtO
AdaD	BreedveldH
Contemporary Modern ArtO
BuismanH
Contemporary Modern ArtO
MoriD
BundH
Contemporary Modern ArtO
LynnD
ChadwickH
Classical ModernO
MarcD
ChagallH
Classical ModernO
148B	DominiqueD
ChanH
Contemporary Modern ArtO
PierreD
CopsH
Contemporary Modern ArtO
Contemporary Modern ArtO
DanielD
CouetH
Contemporary Modern ArtO
ColetteD
CurfsH
Contemporary Modern ArtO
GeorgeD	dEspagnatH
Classical ModernO
HansD
DeussH
Contemporary Modern ArtO
DiekstraH
Contemporary Modern ArtO
HennieD	Van Diest
Error reporting on
Startup script
***** NAVIGATION SCRIPTS *****
Insert row
Insert all artists
G: Layout Populate
goto query1
G: Intro
	G: Create
G: Populate
G: Query 1
G: Query 2
G: Query 3
	G: Update
G: UI
G: Menu
Connect
Execute statement
Create table artists
Create table artworks
Contemporary Modern ArtO
EvertD
Van DijkH
Contemporary Modern ArtO
PaulD
DijkmanH
Contemporary Modern ArtO
Van DoeselaarH
Contemporary Modern ArtO
DoraD
DolzH
Contemporary Modern ArtO
XandraD
DondersH
Contemporary Modern ArtO
BartD
DrostH
Contemporary Modern ArtO
JeanD
DubuffetH
Classical ModernO
LitaD
Van EngelenhovenH
Contemporary Modern ArtO
Van EsH
Contemporary Modern ArtO
FrankD
Van EyndhovenH
Contemporary Modern ArtO
LeonorD
FiniH
Classical ModernO
RobertD
FortgensH
Contemporary Modern ArtO
513B	TsuguharuD
FoujitaH
Classical ModernO
FlipD	GaasendamH
Contemporary Modern ArtO
JolandeD
GernerH
Contemporary Modern ArtO
HarrieD
GerritzH
Contemporary Modern ArtO
CarolienD
GeversH
Contemporary Modern ArtO
GijzenH
Contemporary Modern Art
SietseD
GovertsH
Contemporary Modern ArtO
140B	AnnemarieD
De GrootH
Contemporary Modern ArtO
GrotenbregH
Contemporary Modern ArtO
JurjenD
De HaanH
Contemporary Modern ArtO
LetitiaD
De HaasH
Contemporary Modern ArtO
DianeD
Van HalH
Contemporary Modern ArtO
FerryD
HalewijnH
Contemporary Modern ArtO
ElmaD	Van HarenH
Contemporary Modern ArtO
PattyD
HarpenauH
Contemporary Modern ArtO
HenriD
HaydenH
Classical ModernO
JozinaD
HeesH
Contemporary Modern ArtO
BethuelD
HeldtH
Contemporary Modern ArtO
OttoD
HetterscheidH
Contemporary Modern ArtO
EricD
HirdesH
Contemporary Modern ArtO
Hans P.D
Innem
Contemporary Modern ArtO
DagmarD
Contemporary Modern ArtO
RityD
Jansen-HeijtmajerH
Contemporary Modern ArtO
LeonD
JanssenH
Contemporary Modern ArtO
AlexejD
Von JawlenskyH
Classical ModernO
MichaelD
JepkesH
Contemporary Modern ArtO
FredD
De JongH
Contemporary Modern ArtO
073B	LambertusD
De JongH
Contemporary Modern ArtO
AsgerD
JornH
Classical ModernO
HugoD
KaagmanH
Contemporary Modern ArtO
KlementH
Contemporary Modern ArtO
DorritD
KlompH
Contemporary Modern ArtO
SjaakD
KorstenH
Contemporary Modern ArtO
HenkD
KristH
Contemporary Modern ArtO
ToonD
KuijpersH
Contemporary Modern ArtO
055B	Anne-loreD
KuryszczukH
Contemporary Modern ArtO
MarcD
KuyperH
Contemporary Modern ArtO
LaimbockH
Contemporary Modern ArtO
RuudD
LanfermeijerH
Contemporary Modern ArtO
AndreD
LanskoyH
Classical ModernO
AtiD	LichtveldH
Contemporary Modern ArtO
FrankD
LisserH
Contemporary Modern ArtO
MarkD
LisserH
Contemporary Modern ArtO
Peter
LoumanH
Contemporary Modern ArtO
MaximilienD
LuceH
Classical ModernO
AbrahamD
ttgerH
Contemporary Modern ArtO
AnnekeD
Van De MandeleH
Contemporary Modern ArtO
AdrieD
MartensH
Contemporary Modern ArtO
AndreD
MassonH
Classical ModernO
BeatriceD
Mc Sorley / de JongH
Contemporary Modern ArtO
EritiaD
Van Der MeiH
Contemporary Modern ArtO
SamD	MiddletonH
Contemporary Modern ArtO
ConstantijnD	MolenkampH
Contemporary Modern ArtO
MarionD
MolierH
Contemporary Modern ArtO
NellaD	MontfoortH
Contemporary Modern ArtO
PjotrD	Van MoockH
Contemporary Modern ArtO
MarcoD
MuusseH
Contemporary Modern ArtO
NicolasH
Contemporary Modern ArtO
JeanD
Le NobleH
Contemporary Modern ArtO
LydiaD	OerlemansH
Contemporary Modern ArtO
VincentD
Van OjenH
Contemporary Modern ArtO
OldenhofH
Contemporary Modern ArtO
HenkD
OlijveH
Contemporary Modern ArtO
GertD
OortmerssenH
Contemporary Modern ArtO
SylviaD
OudkerkH
Contemporary Modern ArtO
JilleD
Van De PasH
Contemporary Modern ArtO
SaskiaD	PfaeltzerH
Contemporary Modern ArtO
SariD
PiekH
Contemporary Modern ArtO
TheodoraD
Van Der PlasH
Contemporary Modern ArtO
SimonD
PosthumaH
Contemporary Modern ArtO
FineD
PrastH
Contemporary Modern ArtO
HenkD
Van PuttenH
Contemporary Modern ArtO
LiesbethD
RahderH
Contemporary Modern ArtO
RamirezD
RamirezH
Contemporary Modern ArtO
WalterD
RastH
Contemporary Modern ArtO
MonicaD
Van RijnH
Contemporary Modern ArtO
JacquelineD
Van RosmalenH
Contemporary Modern ArtO
166B	Dadara D.D	RozenbergH
Contemporary Modern ArtO
IngeD
SchagenH
Contemporary Modern ArtO
WillemD
Van ScheijndelH
Contemporary Modern ArtO
MattieD	SchildersH
Contemporary Modern ArtO
185B	Margreet D
ScholtenH
Contemporary Modern ArtO
PeterD
SchruijrenH
Contemporary Modern ArtO
NickD
SeijkensH
Contemporary Modern ArtO
PaulD
SmuldersH
Contemporary Modern ArtO
PeterD
SpaansH
Contemporary Modern ArtO
051B	HenrietteD
SpieringH
Contemporary Modern ArtO
052B	ChristineD	SpieringsH
Contemporary Modern ArtO
HermanD
StaalduinenH
Contemporary Modern ArtO
StallenbergH
Contemporary Modern ArtO
Van SteenselH
Contemporary Modern ArtO
JolandeD
StilH
Contemporary Modern ArtO
JacquesD
TangeH
Contemporary Modern ArtO
FransD
Van TartwijkH
Contemporary Modern ArtO
Lou D
ThissenH
Contemporary Modern ArtO
EricD
ToeboschH
Contemporary Modern ArtO
Ronald D
Tolman
Contemporary Modern ArtO
EllenD
Van ToorH
Contemporary Modern ArtO
MauriceD
UtrilloH
Classical ModernO
HennieD
Van der VegtH
Contemporary Modern ArtO
HansD
VanhorckH
Contemporary Modern ArtO
RuudD
VerkerkH
Contemporary Modern ArtO
130B	Ramon JanD
Contemporary Modern ArtO
Volger/van HarenH
Contemporary Modern ArtO
IljaD
WalravenH
Contemporary Modern ArtO
C.A.D
WertheimH
Contemporary Modern ArtO
LeoD	WijnhovenH
Contemporary Modern ArtO
MeikinaD
WilgenkampH
Contemporary Modern ArtO
Bert D
WilsH
Contemporary Modern ArtO
BertD
Van ZelmH
Contemporary Modern ArtO
MajaD
ZomerH
Contemporary Modern ArtO
	Helvetica
Geneva
Times
Palatino
Arial
Verdana
Insert all artworks
Execute query
Get Column
Get Row
Query3
OnClose
Insert all artists
Yes Lov'it
Noease
Yes Lov'it
Are you sure you want to insert all the artist recordst to the artists table?
(make sure you have allready created the table)B,
) = 2	
|("SQL-doSQL"
	SQL-doSQL
	 = "OK"
Insert row
|("SQL-doSQL"
	SQL-doSQL
G: Layout Populate
goto query1
Startup script
***** NAVIGATION SCRIPTS *****
A0THIS IS NOT A SCRIPT BUT JUST A SCRIPT SEPARATOR
G: Intro
A	G: Create
ivisor )
Month ( date )
Cancelme ( date ) 
NPV ( payment 
 interest
rate )
NumToText ( numWe're ready! Everything went fine!F
onds ( time )
Sign ( numb
Cancelin ( number )
Sqrt ( numbe
Status ( status
flag )
StDevSomething went wrong!
Please enable error reporting (scriptmenu) and check the error!
G: Populate
G: Query 1
G: Query 1 in Artworks
G: Query 2
"SELECT artworks.artwork_number,artworks.title,artworks.price,artists.artist_number,artists.first_name,artists.surname FROM artists, artworks WHERE artists.artist_number = artworks.artist_number AND ((artworks.title Like 'ab%'))"
SELECT artworks.artwork_number,artworks.title,artworks.price,artists.artist_number,artists.first_name,artists.surname FROM artists, artworks WHERE artists.artist_number = artworks.artist_number AND ((artworks.title Like 'ab%'))
G: Query 3
w"create table artists ( artist_number char(3) , first_name varchar(32) , surname varchar(42)  , category varchar(60) )"
ucreate table artists ( artist_number char(3) , first_name varchar(32) , surname varchar(42)  , category varchar(60) )
"create table artworks ( artwork_number varchar(12) , artist_number char(3) , title varchar(255) , maat varchar(12)  , price integer , year integer, extra varchar(255), style varchar(255) , category varchar(255) )"
create table artworks ( artwork_number varchar(12) , artist_number char(3) , title varchar(255) , maat varchar(12)  , price integer , year integer, extra varchar(255), style varchar(255) , category varchar(255) )
A	G: Update
G: Update in Artworks
G: UI
G: UI in Artworks
G: Menu
Connect
|("SQL-open"
SQL-open
|("SQL-open"
SQL-open
|("SQL-open"
 & "|" & 
SQL-open
|("SQL-open"
 & "|"  & 
 & "|" & 
SQL-open
Execute statement
"SELECT artworks.artwork_number,artworks.title,artworks.price,artists.artist_number,artists.first_name,artists.surname FROM artists, artworks WHERE artists.artist_number = artworks.artist_number AND ((artworks.title Like 'ab%'))"
SELECT artworks.artwork_number,artworks.title,artworks.price,artists.artist_number,artists.first_name,artists.surname FROM artists, artworks WHERE artists.artist_number = artworks.artist_number AND ((artworks.title Like 'ab%'))
Error reporting on
|("SQL-enableReporting"
 "1")
SQL-enableReporting
Create table artists
ax ( field... )
Middle ( 
Noncelstart ; size )7
MiddleWords
( text ; starting
word ; number
oDo you want to create the table artists now?B,
) = 1	
w"create table artists ( artist_number char(3) , first_name varchar(32) , surname varchar(42)  , category varchar(60) )"
ucreate table artists ( artist_number char(3) , first_name varchar(32) , surname varchar(42)  , category varchar(60) )D9
|("SQL-doSQL"
	SQL-doSQL
	 = "OK"
|("SQL-doSQL"
	SQL-doSQL
Create table artworks
ax ( field... )
Middle ( 
Noncelstart ; size )7
MiddleWords
( text ; starting
word ; number
oDo you want to create the table artworks now?B,
) = 1	
"create table artworks ( artwork_number varchar(12) , artist_number char(3) , title varchar(255) , maat varchar(12)  , price integer , year integer, extra varchar(255), style varchar(255) , category varchar(255) )"
create table artworks ( artwork_number varchar(12) , artist_number char(3) , title varchar(255) , maat varchar(12)  , price integer , year integer, extra varchar(255), style varchar(255) , category varchar(255) )
|("SQL-doSQL"
	SQL-doSQL
ivisor )
Month ( date )
Cancelme ( date ) 
NPV ( payment 
 interest
rate )
NumToText ( numThe table has been correctly createdG
ivisor )
Month ( date )
Cancelme ( date ) 
NPV ( payment 
 interest
rate )
NumToText ( numSomething went wrong! Enable error reporting for details!
Insert all artworks
Yes Lov'it
Noease
Yes Lov'it
Are you sure you want to insert all the records of artworks in your datasource?
It could take some time, please be patient (nearly 2000 records)B,
) = 2	
Insert all in artworksD-
 = "OK"
ivisor )
Month ( date )
Cancelme ( date ) 
NPV ( payment 
 interest
rate )
NumToText ( numWe're ready! Everything went fine!F
onds ( time )
Sign ( numb
Cancelin ( number )
Sqrt ( numbe
Status ( status
flag )
StDevSomething went wrong!
Please enable error reporting (scriptmenu) and check the error!
Execute query
	 = "OK"
ivisor )
Month ( date )
Cancelme ( date ) 
NPV ( payment 
 interest
rate )
NumToText ( numThe table has been correctly createdG
ivisor )
Month ( date )
Cancelme ( date ) 
NPV ( payment 
 interest
rate )
NumToText ( numSomething went wrong! Enable error reporting for details!
|("SQL-execQuery"
SQL-execQuery
Get Column
|("SQL-getColumn"
SQL-getColumn
Get Row
|("SQL-getRow"
SQL-getRow
Query3
|("SQL-execQuery"
SQL-execQuery
) = 1	
|("SQL-exportRows"
SQL-exportRows
|("SQL-exportRows"
 "C:\tempf.tab")
SQL-exportRows
C:\tempf.tab|
OnClose
)3)!Z
Z)3!BZc!)
!BZR!)
ORPTH
FPTHAOMacintosh HD:Desktop Folder:FileMaker Pro 4.0 Folder:SQL Example:Artworks Clone
MSPCA
NAMEA
Artworks Clone
RPTHA
Artworks Clone
Macintosh HD
Artworks Clone
tFMP3FMP3
SQL Example
OMacintosh HD:Desktop Folder:FileMaker Pro 4.0 Folder:SQL Example:Artworks Clone
IRPTH
	MSPC
FPTHAIMacintosh HD:Desktop Folder:FileMaker Pro 4.0 Folder:SQL Example:Artworks
MSPCA
NAMEA	
Artworks
RPTHA
Artworks
alisA
alisA
FPTHA
	ZONE
NAMEA	
Artworks
ZONEA
<RPTH
	alis
FPTHA<Macintosh HD:Desktop Folder:FileMaker Pro 4.0 Folder:sql.txt
MSPCA
NAMEA
sql.txt
RPTHA	::sql.txt
Macintosh HD
sql.txt
TEXTttxt
FileMaker Pro 4.0 Folder
<Macintosh HD:Desktop Folder:FileMaker Pro 4.0 Folder:sql.txt
~NAME
FPTHA
Macintosh HD:SQL Example:li
MSPCA
NAMEA
RPTHA
Macintosh HD
Artworks
tFMP3FMP3
SQL Example
IMacintosh HD:Desktop Folder:FileMaker Pro 4.0 Folder:SQL Example:Artworks
!RPTH
	MSPC
FPTHA!Macintosh HD:SQL Example:Artworks
MSPCA
NAMEA	
Artworks
RPTHA
Artworks
Macintosh HD
Artworks
tFMP3FMP3
SQL Example
!Macintosh HD:SQL Example:Artworks
PB 1400
Macintosh HD
NAMEA
Artworks.fp3
RPTHA
ARTWORKS.FP3
SRPTA
ARTWORKS.FP3
WSPCA
D:\dev\SQL Example\
NAMEA
li.fp3
RPTHA
LI.FP3
SRPTA
LI.FP3
WSPCA
D:\dev\SQL Example\
NRPTH
Macintosh HD
FMP3FMP3
SQL Example
Macintosh HD:SQL Example:li
PB 1400
Macintosh HD
HRPTH
FPTHAHMacintosh HD:Development:Plugins:SQL Plugin:SQLPlugin:SQL Example:li.fp3
MSPCA
NAMEA
li.fp3
RPTHA
li.fp3
Macintosh HD
li.fp3
FMP3FMP3
SQL Example
HMacintosh HD:Development:Plugins:SQL Plugin:SQLPlugin:SQL Example:li.fp3
FMRLA
FMRLA
ArtworksB
Lines | Constant
FPTHANMacintosh HD:Development:Plugins:SQL Plugin:SQLPlugin:SQL Example:Artworks.fp3
MSPCA
NAMEA
Artworks.fp3
RPTHA
Artworks.fp3
Macintosh HD
Artworks.fp3
FMP3FMP3
SQL Example
NMacintosh HD:Development:Plugins:SQL Plugin:SQLPlugin:SQL Example:Artworks.fp3
Pro 3.0 - 4.0F!
Pro 3.0 - 4.1M1
zondag
maandag
dinsdag
woensdag
	donderdag
vrijdag
zaterdag
januari
februari
maart
april
augustus
	september
oktober
november
december
1st Quarter
2nd Quarter
3rd Quarter
4th Quarter